<?php include("head.php"); ?>
    <div class="sui-layout">
		  <div class="sidebar">
<?php include("leftmenu.php"); ?>	  	
		  </div>
		  <div class="content">
			<p class="sui-text-xxlarge my-padd">学生信息</p>
            <!-- 所有课程的列表 -->
            <table class="sui-table table-primary">
                <tr><th>sid</th><th>学号</th><th>姓名</th><th>籍贯</th><th>手机号</th><th>班号</th></tr>
                <?php
                    include("conn.php");
                    $xuehao = $_REQUEST["xuehao"];
                    $names = $_REQUEST["names"];
                    //执行sql语句
                    $sql = "select * from student where 姓名='{$names}' and 学号='{$xuehao}'";
                    $result = mysqli_query($conn,$sql);
                    if( mysqli_num_rows($result)>0 ){
                        while ($arr = mysqli_fetch_assoc($result)){
                            echo "<tr>
                                <td>{$arr['sid']}</td>
                                <td>{$arr['学号']}</td>
                                <td>{$arr['姓名']}</td>
                                <td>{$arr['籍贯']}</td>
                                <td>{$arr['手机号']}</td>
                                <td>{$arr['班号']}</td>
                            </tr>";
                        }
                    }else{
                        echo "暂没有记录";
                    }
                ?>
            </table>
		  </div>
		</div>		
    </div>
<?php include("foot.php"); ?>